package ebcs.database.service;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Service;

import ebcs.database.bean.BsGroupInfor;
public interface BsGroupInforServiceImp
{
 	//查询团队信息
	public List<BsGroupInfor> searchGroupList();
	//根据编号和团队名模糊查询
	public List<BsGroupInfor> selectGroupDetail(BsGroupInfor group);
	public List<BsGroupInfor> selectGroupDetailPage(BsGroupInfor group);
	public int selectGroupDetailCount(BsGroupInfor group);
	//根据团队名查询
	public List<BsGroupInfor> selectGroupByGroupName(String groupName);
	//根据编号更新记录的团队名称和经理名称
	public int updateGroupByGroupNo (BsGroupInfor group);
	public int deleteGroupByGroupNo (String proGroupNo);
	//查询最大值的rouid
	public String selectGroupMaxRouId();
	public int insertGroupInfor(BsGroupInfor group);
	
	//查询所有的团队经理openid及姓名
    List<BsGroupInfor> selectGroupOpenid(String groupNo);
  //根据userinforRouid查询团队经理
    List<BsGroupInfor> selectGroupByUserRouid(String rouid);
    //根据项目组id查询团队经理的信息
    List<BsGroupInfor> selectGroupByProTeamNo(@Param("proTeamNo") String proTeamNo);
  //查询所有的团队经理
    List<BsGroupInfor> selectGroupname();  
    //根据userNo查询ProGroupNo yf 
    List<BsGroupInfor> selectProGroupNoByUserNo(String userNo);
    
 }
